Sqlite3 prompting `...>` instead of `sqlite>`

Posted by Imray on Stack Overflow See other posts from Stack Overflow or by Imray
Published on 2013-10-31T15:45:19Z Indexed on 2013/10/31 15:53 UTC
Read the original article Hit count: 217

Filed under:

I'm following a beginners tutorial to sqlite3. The first step is creating a new database. So I enter a name (movies.db).

I'm expecting to get another sqlite> prompt on the next line, and continue with the tutorial, but instead I get a lame ...> after which I can type any gibbersish I want. Clearly, this is not good.

What my command prompt looks like:

SQLite version 3.8.1 2013-10-17 12:57:35
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> $ sqlite3 movies.db
   ...> gibberish
   ...> dsds
   ...> sdada
   ...> gfgys
   ...> a
   ...> Aaaaarrrgh!
   ...>

How do I get sqlite3 to work normally for me?

Pardon my newbie-ness. I hope I've phrased this question in a way that might help other newbs too.

© Stack Overflow or respective owner

Related posts about sqlite3